You are here: 1. Distribution System > 1.5. INVENTORY Menu: Purchasing and Stock Control > 1.5.11. Inventory - Reconcile Uncosted Imports > Maintaining the Reconcile Imports Header

Maintaining the Reconcile Imports Header

When you load an uncosted imports batch, Micronet loads all the items received in the shipment and displays them on the Reconcile Imports screen. If there is only one invoice for a shipment, you simply enter the invoice details on the default Reconcile Imports Header screen.

However, there may be more than one supplier invoice associated with a shipment, e.g. separate invoices from different suppliers or for different goods received in the shipment. In this case, you need to enter the details of each invoice on a new Reconcile Imports Header screen.

To enter the details of a shipment's first and subsequent supplier invoices:

  1. Load the uncosted imports batch you want to reconcile.

Refer to "Recalling an Uncosted Imports Batch".

Micronet displays the Reconcile Imports screen.

  1. If there is more than one invoice associated with the shipment, select the supplier invoice you want to reconcile.

Refer to "Reconcile Imports - Change Invoice".

Micronet displays the item lines associated with the selected invoice.

  1. Select HEADER.

Micronet displays the Reconcile Imports Header screen.

  1. Complete the following fields:

 

Field

Value

 

Shipment Name

Micronet displays the shipment name entered when the import costing batch was created. You can change this if required.

 

Shipment Number

Micronet displays the shipment number entered when the import costing batch was created. You can change this if required.

 

Supplier

Micronet displays the ID and description of the supplier of the imported goods. You can change this if required.

 

Date

Micronet displays today's date. Enter or select a different date for this reconciliation if required.

 

Appropriation

Select the appropriation method you want to distribute your costs by. Options are:

  • Price – This is the default option. Micronet totals the shipment on-costs and averages the costs over items by their value as a percentage of the entire shipment cost.
  • Volume – Micronet totals the shipment on-costs and averages the costs over items by the volume they occupied of the total shipment. You are later asked for the total shipment volume.
  • Weight – Micronet totals the shipment on-costs and averages the costs over items by their percentage weight of the whole shipment.

Use the second drop down list to select whether you want the costs averaged:

  • Per Invoice – Each supplier invoice within the shipment has separate and distinct import charges. Micronet appropriates and averages the cost over only the items on the specific invoice. You enter the import charges for a specific supplier invoice into the relevant Reconcile Imports Header dialogue.
  • Total Import – Costs relate to the shipment as a whole. Where there are multiple supplier invoices in the shipment, Micronet appropriates the cost over all the items in the shipment. You enter the import charges into the first Reconcile Imports Header dialogue in the shipment. All subsequent Reconcile Imports Header dialogues should be left blank.

 

 

Technical Tip

Weights and volumes can be directly updated to the Inventory master file from the import costing transaction screens.

 

 

Invoice Number

Enter the supplier's invoice number.

When you enter an invoice number, the information you enter in the Reconcile Imports Header screen updates the Creditors Ledger transaction files.

 

Invoice Date

Enter the date on the supplier's invoice. This date will be posted to the Micronet Creditors Ledger (MCL).

 

FOB Invoice Amount

Enter the total invoice amount from the supplier's invoice in your supplier's base currency. The supplier's exchange rate ID appears next to the Invoice Amount.

 

 

Technical Tip

Only enter the value of the goods or inventory appearing on the supplier's invoice. Do not include any freight or other chargeable component, as these items are considered landed charges and should be appropriated over the value of the products in the shipment or on that invoice. They are entered elsewhere in the import costing transaction.

 

 

FOB Exch

Enter the exchange rate for the Free on Board (FOB) amount. Micronet defaults to the current exchange rate applicable to your supplier from the Exchange Rates master file. You may accept the default or override/enter the exchange rate as applicable.

 

Duty

There are two ways to appropriate duty on goods. These are:

  • Duty Tables – duty rates vary on products and appropriation of cost must be by each item
  • Set Duty Rate – one duty rate is applicable to all imported items, therefore appropriation of cost is similar to other import cost charges.

When you move to this field, Micronet displays the Enter Duty Charge screen. Only use this screen if duty tables have been setup. Leave all the fields blank if there is one duty rate applicable to all imported items (see the note below).

Complete the following fields:

  • Duty (inc GST) – if you know the duty figure, enter it - that is, the duty charge + GST for the goods as charged by Customs. If not, you may accept the default of 0.00 and come back to enter the duty figure when you know it.
  • Supplier – select a supplier
  • Reference – enter the supplier invoice number
  • Date – enter the invoice date
  • GST Amount – enter the GST component of the Duty (inc GST) amount.

Select the OK button to return to the Reconcile Imports Header screen.

 

 

Technical Tip

Where the duty rate on all imported goods is the same, duty charges can be appropriated by the same method as other import charges - that is, using the Total Charges field below.

 

 

Exchange Duty

Enter the exchange rate to calculate the duty amount. Micronet defaults to the current exchange rate applicable to your supplier. You may accept the default or override/enter the exchange rate as applicable, i.e.:

Duty = ItemFOB/ExchangeDuty * Duty%/100

 

Invoice Total

 

 

Total Charges

When you move to this field, Micronet displays the Import Costing Charges screen. Refer to "Reconcile Imports Header - Import Costing Charges" for more information.

 

Import Charges

 

 

Deferred GST

If you are registered in the “Deferred GST Scheme” with the ATO, enter the GST amount here. Micronet will post the relevant figures to the General Ledger.

 

Loading Rate

As items are received, the calculated item landed cost price can be loaded by a percentage increase. The increased cost price is posted to Stock On Hand and Goods Received in your GL. The Loading Rate is a percentage rate that can be applied to the calculated item landed cost price. For example, if the new landed cost was $12.00 and you had a loading of 10%, then Micronet would receipt the item at a total cost price of $12.00 + 10% = $13.20.

  1. Optionally, you can perform a supplier inquiry if required.

Refer to "Reconcile Imports Header - Inquiry".

  1. When you have finished entering the invoice details on the uncosted imports header, select PROCEED or press F2.

Micronet displays the Dissect Import Cost screen. Refer to "Dissecting an Uncosted Import" for information on using that screen.